Framework for The Integrated And Validated Model of Data Warehouse

A Data warehouse has its own set of challenges for security. Organizational data warehouse are often very large systems. Once we have extracted and loaded the data from heterogeneous sources we need to integrated the data as it seems to similar but coming from the different sources. Validation is required at all the design phases of the development of the data warehouse. With the rapid development and implementation of the data warehouse, security problems arise in populating a warehouse with the enterprise data. For the periods many researchers work on the designing phases of the data warehouse but no research gathers the causes of the security issues. There are some malicious attempts and the vulnerabilities occurring at the levels of abstraction. In this paper we identified the malicious attempts and the vulnerabilities at validation phase through conceptual level modeling and propose the framework of the integrated and validated model of data warehouse.